<!DOCTYPE html>
<html>
<head>
	<title></title>
	<link rel="stylesheet" type="text/css" href="../公用CSS文件/all.css" />
	<script type="text/javascript" src="../js/jquery.min.js"></script> 	<script type="text/javascript" src="../js/js.js"></script>
	<meta charset="utf-8">
	<style type="text/css">
		table{width:80%}
	</style>
</head>
<body>

<div class="dt">腾讯地图定位</div>
<ul>
	
</ul>



</body>
</html>


SELECT `uc`.*,`u`.`name`,`c`.`title`,`c`.`currentprice` FROM `ims_mzhk_sun_coupon` `c` LEFT JOIN `ims_mzhk_sun_user_coupon` `uc` ON `c`.`id`=`uc`.`cid` LEFT JOIN `ims_mzhk_sun_user` `u` ON `u`.`openid`=`uc`.`uid` WHERE ( and uc.isUsed = 1 ) ORDER BY `id` DESC LIMIT 0,10

SELECT `uc`.*,`u`.`name`,`c`.`title`,`c`.`currentprice` FROM `ims_mzhk_sun_coupon` `c` LEFT JOIN `ims_mzhk_sun_user_coupon` `uc` ON `c`.`id`=`uc`.`cid` LEFT JOIN `ims_mzhk_sun_user` `u` ON `u`.`openid`=`uc`.`uid` ORDER BY `id` DESC LIMIT 0,10